APPS.JAI_PO_OSP_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 75: from po_distributions_all

71: lv_called_po := 'PO';
72:
73: For c_Line_rec in
74: (Select distinct po_line_id
75: from po_distributions_all
76: where po_header_id = p_po_header_id
77: and
78: ( ( p_called_from = lv_called_release and po_release_id = p_po_release_id) --'RELEASE' /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
79: OR

Line 271: CURSOR c_check_reqmt_ops( cp_wip_entity_id po_distributions_all.wip_entity_id%TYPE , cp_wip_op_seq_num po_distributions_all.wip_operation_seq_num%TYPE) IS

267: WHERE routing_sequence_ID = cp_routing_seq_id
268: AND operation_seq_num < cp_wip_operation ;
269:
270:
271: CURSOR c_check_reqmt_ops( cp_wip_entity_id po_distributions_all.wip_entity_id%TYPE , cp_wip_op_seq_num po_distributions_all.wip_operation_seq_num%TYPE) IS
272: SELECT count(1)
273: FROM wip_requirement_operations
274: WHERE wip_entity_id = cp_wip_entity_id
275: AND operation_seq_num = cp_wip_op_seq_num

Line 364: FROM po_distributions_all

360: destination_organization_id orgn_id ,
361: deliver_to_location_id loc_id ,
362: wip_entity_id, wip_operation_seq_num,
363: wip_repetitive_schedule_id, wip_line_id
364: FROM po_distributions_all
365: WHERE po_header_id = p_po_header_id
366: and po_line_id = rec_po_line_cur.po_line_id
367: and
368: ( ( p_called_from = 'RELEASE' and po_release_id = p_po_release_id)

Line 774: FROM po_distributions_all

770:
771: CURSOR c_po_dist_info IS
772: SELECT po_distribution_id, wip_entity_id, wip_line_id,
773: wip_repetitive_schedule_id, wip_operation_seq_num
774: FROM po_distributions_all
775: WHERE line_location_id = r_base_trx.po_line_location_id
776: AND ROWNUM = 1;
777:
778: CURSOR c_assembly_id(cp_wip_entity NUMBER) IS

Line 1188: FROM po_distributions_all

1184:
1185: --**********FETCHING VALUES FROM RCV_TRANSACTIONS**********
1186: CURSOR c_get_rcv_trans IS
1187: SELECT wip_entity_id
1188: FROM po_distributions_all
1189: WHERE line_location_id = p_po_line_location_id
1190: AND rownum = 1;
1191:
1192: -- 2746952

Line 1229: from po_distributions_all

1225:
1226: -- sriram - bug # 3021456
1227: cursor c_po_qty_cur(p_po_hdr_id number , p_po_line_id number) is
1228: select quantity_ordered
1229: from po_distributions_all
1230: where po_header_id = p_po_hdr_id
1231: and po_line_id = p_po_line_id;
1232:
1233: v_item_pr_uom_code mtl_system_items.primary_uom_code%TYPE; -- eg. Ea