DBA Data[Home] [Help]

APPS.MRP_PO_RESCHEDULE dependencies on STANDARD

Line 407: and type_lookup_code IN ('STANDARD', 'BLANKET', 'PLANNED');

403: CURSOR c_po_header (p_po_number VARCHAR2) IS
404: select po_header_id
405: from po_headers
406: where segment1 = p_PO_NUMBER
407: and type_lookup_code IN ('STANDARD', 'BLANKET', 'PLANNED');
408: */
409: DISTRIBUTION_LVL CONSTANT NUMBER := 0;
410: SHIPMENT_LVL CONSTANT NUMBER := 1;
411: PO_LINE_LVL CONSTANT NUMBER := 2;

Line 681: order number(shipment number) -- standard PO */

677: /* in R12, order number(release number)(line number)(shipment number),
678: but release number could be empty,
679: in 11.5.10 and prior,
680: order number(release number)(shipment number) -- blanket PO or
681: order number(shipment number) -- standard PO */
682:
683: first_left_pare_pos := instr(v_po_number(i), '(');
684: second_left_pare_pos := instr(v_po_number(i), '(',1,2);
685: third_left_pare_pos := instr(v_po_number(i), '(',1,3);

Line 702: l_doc_subtype := 'STANDARD';

698: end;
699:
700: if v_release_num is null then
701: l_doc_type := 'PO';
702: l_doc_subtype := 'STANDARD';
703: v_po_number(i) := substr(v_po_number(i), 1,first_left_pare_pos -1);
704: else
705: l_doc_type := 'RELEASE';
706: l_doc_subtype := 'BLANKET';