APPS.PO_NEGOTIATIONS_SV1 dependencies on PO_SESSION_GT

Line 497: DELETE FROM po_session_gt WHERE index_char1='PO_NEGOTIATIONS_SV1';

493: x_num_records := t_req_lines.COUNT;
494:
495: --bug 6131913
496:
497: DELETE FROM po_session_gt WHERE index_char1='PO_NEGOTIATIONS_SV1';
498:
499:
500:
501: --bug 5841426

Line 503: INSERT INTO po_session_gt (KEY, index_char1, char1, num1, num2, num3, date1)

499:
500:
501: --bug 5841426
502: FORALL i IN 1..t_req_lines.Count
503: INSERT INTO po_session_gt (KEY, index_char1, char1, num1, num2, num3, date1)
504: SELECT prl.requisition_line_id,
505: 'PO_NEGOTIATIONS_SV1',
506: prh.segment1,
507: prl.line_num,

Line 564: PO_SESSION_GT psg --

560: l_from_org_id */ --
561: from po_requisition_lines_all rl, --
562: mtl_system_items_kfv msi,
563: per_jobs_vl PJ,
564: PO_SESSION_GT psg --
565: where requisition_line_id = psg.key --
566: and rl.item_id = msi.inventory_item_id(+)
567: and nvl(msi.organization_id, rl.destination_organization_id) =
568: rl.destination_organization_id