APPS.OE_ORDER_COPY_UTIL dependencies on OE_ORDER_LINES_ALL

Line 3533: From oe_order_lines_all ooh,Oe_invoice_to_orgs_v oit

3529: IN ('CREDIT_CARD','ACH','DIRECT_DEBIT','CASH','CHECK','WIRE_TRANSFER') THEN
3530:
3531: Select oit.customer_id, ooh.invoice_to_org_id
3532: Into l_invoice_to_cust_id, l_invoice_to_org_id
3533: From oe_order_lines_all ooh,Oe_invoice_to_orgs_v oit
3534: Where ooh.line_id = x_line_payment_tbl(I).line_id
3535: And oit.organization_id = ooh.invoice_to_org_id;
3536:
3537: -- need to create a new trxn extension id and populate

Line 6025: FROM oe_order_lines_all l

6021: -- Cursor for finding all lines belonging to a particular ship set from source order.
6022: CURSOR line_cur_ship(p_set_id IN NUMBER)
6023: IS
6024: SELECT l.line_id
6025: FROM oe_order_lines_all l
6026: WHERE l.ship_set_id = p_set_id;
6027:
6028: -- Cursor for finding all lines belonging to a particular arrival set from source order.
6029: CURSOR line_cur_arrival(p_set_id IN NUMBER)

Line 6032: FROM oe_order_lines_all l

6028: -- Cursor for finding all lines belonging to a particular arrival set from source order.
6029: CURSOR line_cur_arrival(p_set_id IN NUMBER)
6030: IS
6031: SELECT l.line_id
6032: FROM oe_order_lines_all l
6033: WHERE l.arrival_set_id = p_set_id;
6034:
6035: -- Cursor for finding all lines belonging to a particular fulfillment set from source order.
6036: CURSOR line_cur_fulfill(p_set_id IN NUMBER)

Line 6039: FROM oe_order_lines_all l,

6035: -- Cursor for finding all lines belonging to a particular fulfillment set from source order.
6036: CURSOR line_cur_fulfill(p_set_id IN NUMBER)
6037: IS
6038: SELECT l.line_id
6039: FROM oe_order_lines_all l,
6040: oe_line_sets ols
6041: WHERE l.line_id = ols.line_id
6042: AND l.header_id = p_old_header_id
6043: AND ols.set_id = p_set_id;