APPS.OE_ORDER_COPY_UTIL dependencies on OE_ORDER_LINES_ALL

Line 3383: From oe_order_lines_all ooh,Oe_invoice_to_orgs_v oit

3379: IN ('CREDIT_CARD','ACH','DIRECT_DEBIT','CASH','CHECK','WIRE_TRANSFER') THEN
3380:
3381: Select oit.customer_id, ooh.invoice_to_org_id
3382: Into l_invoice_to_cust_id, l_invoice_to_org_id
3383: From oe_order_lines_all ooh,Oe_invoice_to_orgs_v oit
3384: Where ooh.line_id = x_line_payment_tbl(I).line_id
3385: And oit.organization_id = ooh.invoice_to_org_id;
3386:
3387: -- need to create a new trxn extension id and populate

Line 5833: FROM oe_order_lines_all l

5829: -- Cursor for finding all lines belonging to a particular ship set from source order.
5830: CURSOR line_cur_ship(p_set_id IN NUMBER)
5831: IS
5832: SELECT l.line_id
5833: FROM oe_order_lines_all l
5834: WHERE l.ship_set_id = p_set_id;
5835:
5836: -- Cursor for finding all lines belonging to a particular arrival set from source order.
5837: CURSOR line_cur_arrival(p_set_id IN NUMBER)

Line 5840: FROM oe_order_lines_all l

5836: -- Cursor for finding all lines belonging to a particular arrival set from source order.
5837: CURSOR line_cur_arrival(p_set_id IN NUMBER)
5838: IS
5839: SELECT l.line_id
5840: FROM oe_order_lines_all l
5841: WHERE l.arrival_set_id = p_set_id;
5842:
5843: -- Cursor for finding all lines belonging to a particular fulfillment set from source order.
5844: CURSOR line_cur_fulfill(p_set_id IN NUMBER)

Line 5847: FROM oe_order_lines_all l,

5843: -- Cursor for finding all lines belonging to a particular fulfillment set from source order.
5844: CURSOR line_cur_fulfill(p_set_id IN NUMBER)
5845: IS
5846: SELECT l.line_id
5847: FROM oe_order_lines_all l,
5848: oe_line_sets ols
5849: WHERE l.line_id = ols.line_id
5850: AND l.header_id = p_old_header_id
5851: AND ols.set_id = p_set_id;