APPS.GMS_PO_ADL_PKG dependencies on PO_REQUISITION_LINES_ALL

Line 55: po_requisition_lines_all porl_old,

51: rd_old.distribution_id old_distribution_id,
52: rd_old.award_id award_set_id
53: from po_req_distributions_all rd_old,
54: po_req_distributions_all rd_new,
55: po_requisition_lines_all porl_old,
56: po_requisition_lines_all porl_new,
57: po_distributions pod,
58: po_headers_all blanket
59: where porl_new.requisition_line_id = nvl(p_req_line_id, -1 )

Line 56: po_requisition_lines_all porl_new,

52: rd_old.award_id award_set_id
53: from po_req_distributions_all rd_old,
54: po_req_distributions_all rd_new,
55: po_requisition_lines_all porl_old,
56: po_requisition_lines_all porl_new,
57: po_distributions pod,
58: po_headers_all blanket
59: where porl_new.requisition_line_id = nvl(p_req_line_id, -1 )
60: and rd_new.requisition_line_id = porl_new.requisition_line_id

Line 75: po_requisition_lines_all porl_new

71: rd_old.distribution_id old_distribution_id,
72: rd_old.award_id award_set_id
73: from po_req_distributions_all rd_old,
74: po_req_distributions_all rd_new,
75: po_requisition_lines_all porl_new
76: where porl_new.requisition_line_id = nvl(p_req_line_id, -1 )
77: and rd_new.requisition_line_id = porl_new.requisition_line_id
78: and rd_new.award_id is null
79: and rd_old.award_id is not null