Ranganath's Oracle Apps

1)At what stage an order cannot be cancelled? If the order is Pick Confirmed, it cannot be cancelled. 2) What are the Process Constraints? Processing Constraints allow Order Management users the ability to control changes to sales orders, at all stages of its order or line workflows to avoid data inconsistencies and audit problems 3)What is a Pick Slip Report?  Pick slip is a shipping document that the pickers use to locate items in the warehouse/ inventory to ship for an order. 4)When the order import program is run it validates and the errors occurred can be seen in? Order Management Responsibility >Orders, Returns : Import Orders> Corrections 5)How is move order generated? When the order is pick released 6)What are primary and secondary price lists? Price list contains information on items and its prices. The pricing engine uses secondary price lists when it cannot determine the price for an item using the price list assigned to an order. What is...

1.CANCELLED PO ’S SELECT PHA . SEGMENT1 ,          PHA . CREATION_DATE ,          PLA . CANCEL_DATE ,          PLA . CANCEL_REASON ,          PLA . ITEM_DESCRIPTION ,          HRL . LOCATION_CODE ,          FU . USER_NAME ,          DECODE ( PHA . CANCEL_FLAG , 'Y' , ’CANCELLED’) STATUS FROM PO_HEADERS_ALL PHA , PO_LINES_ALL PLA , HR_LOCATIONS HRL , FND_USER FU          WHERE PHA . PO_HEADER_ID = PLA . PO_HEADER_ID          AND HRL . LOCATION_ID = PHA . SHIP_TO_LOCATION_ID          AND PHA . CREATED_BY = FU . USER_ID          AND PHA . CANCEL_FLAG = 'Y' 2.PENDING PO ’S SELECT    PHA...

CREATE OR REPLACE PROCEDURE SUPP_AP_INVOICES_PKG( errbuf OUT VARCHAR2, retcode OUT VARCHAR2) AS CURSOR c1 IS SELECT    org_id,  invoice_type_lookup_code,  vendor_num, vendor_name,    vendor_site_code,  invoice_num,  invoice_date, invoice_currency_code,  invoice_amount,  gl_date,  payment_currency_code,  terms_date,  terms_name,  payment_method_lookup_code,  description,  exchange_rate,  exchange_rate_type,  exchange_date,  doc_category_code,   voucher_num,  attribute_category,  attribute1,  attribute2,  attribute3,  attribute4,  attribute5,  attribute6,  attribute7,  attribute8,  attribute9,  SOURCE  FROM SUPP_INVOICE_HEADER_STG; cursor c2(p_invoice_num IN VARCHAR2) IS SELECT  a.org_id,  a.vendor_num, a.invoice_num, a.po_number, a.line_number, a.line_type,  a.amount,...