DBA Data[Home] [Help]

APPS.JAI_OM_RG_PKG dependencies on OE_ORDER_LINES_ALL

Line 1168: FROM oe_order_lines_all

1164: -- cursor to get order source id, when 10 this means that it is an internal sales order(iso)
1165: -- this also gets other details to link to requisition side and the from org id.
1166: CURSOR c_get_order_details(p_header_id NUMBER, p_line_id NUMBER) IS
1167: SELECT ship_from_org_id, order_source_id, source_document_id, source_document_line_id
1168: FROM oe_order_lines_all
1169: WHERE header_id = p_header_id
1170: AND line_id = p_line_id;
1171:
1172: -- get the to organization id from the requisition details

Line 3498: FROM oe_order_lines_all

3494: -- cursor to get order source id, when 10 this means that it is an internal sales order(iso)
3495: -- this also gets other details to link to requisition side and the from org id.
3496: CURSOR c_get_order_details(p_header_id NUMBER, p_line_id NUMBER) IS
3497: SELECT ship_from_org_id, order_source_id, source_document_id, source_document_line_id
3498: FROM oe_order_lines_all
3499: WHERE header_id = p_header_id
3500: AND line_id = p_line_id;
3501:
3502: -- get the to organization id from the requisition details