APPS.XNB_CMN_PVT dependencies on OE_ORDER_LINES_ALL

Line 777: oe_order_lines_all oline

773:
774: SELECT ohdr.order_number
775: INTO l_order_num
776: FROM oe_order_headers_all ohdr,
777: oe_order_lines_all oline
778: WHERE ohdr.header_id = oline.header_id
779: AND oline.line_id = l_doc_no;
780:
781: EXCEPTION

Line 1196: oe_order_lines_all oline

1192:
1193: SELECT ohdr.order_number
1194: INTO l_order_num
1195: FROM oe_order_headers_all ohdr,
1196: oe_order_lines_all oline
1197: WHERE ohdr.header_id = oline.header_id
1198: AND oline.line_id = l_line_id;
1199:
1200: EXCEPTION

Line 1213: SELECT org_id into l_org_id from oe_order_lines_all

1209: END;
1210:
1211: l_key := 'XNB:'||'SALESORDER_LINE : '||l_order_num||':'||l_line_id;
1212:
1213: SELECT org_id into l_org_id from oe_order_lines_all
1214: WHERE line_id = l_line_id;
1215:
1216: wf_event.AddParameterToList(p_name =>'SALES_ORDER_ID',p_value => l_line_id,p_parameterlist => l_parameter_list);
1217: wf_event.AddParameterToList(p_name =>'SALE_ORG_ID',p_value => l_org_id,p_parameterlist => l_parameter_list);

Line 2052: oe_order_lines_all line,

2048:
2049: SELECT count(line.line_id)
2050: INTO l_num
2051: FROM oe_order_headers_all head,
2052: oe_order_lines_all line,
2053: mtl_system_items_vl item
2054: WHERE head.order_number = l_order_number
2055: AND head.header_id = line.header_id
2056: AND line.inventory_item_id = item.inventory_item_id