APPS.PO_DRAFTS_PVT dependencies on PO_DISTRIBUTIONS_DRAFT_ALL

Line 424: FROM po_distributions_draft_all pdd

420: AND poel.entity_name = G_LOCK_DIST_ENTITY
421: )
422: -- : Stamping revision_num for newly added shipment on mod.
423: OR EXISTS ( SELECT 'New Distribution'
424: FROM po_distributions_draft_all pdd
425: WHERE pdd.po_distribution_id = pda.po_distribution_id
426: AND pdd.draft_id = p_draft_id
427: AND pdd.change_status = 'NEW'
428: )

Line 3798: UPDATE po_distributions_draft_all

3794: WHERE draft_id = p_draft_id
3795: AND change_accepted_flag IS NULL;
3796:
3797: d_position := 60;
3798: UPDATE po_distributions_draft_all
3799: SET change_accepted_flag = l_change_accepted_flag
3800: WHERE draft_id = p_draft_id
3801: AND change_accepted_flag IS NULL;
3802:

Line 5024: FROM po_distributions_draft_all pod_draft

5020: 'S'
5021: FROM po_lines_all pol,
5022: po_drafts dft
5023: WHERE EXISTS ( SELECT po_distribution_id -- new distribution added
5024: FROM po_distributions_draft_all pod_draft
5025: WHERE pod_draft.po_line_id = pol.po_line_id
5026: AND pod_draft.draft_id = p_draft_id
5027: MINUS
5028: SELECT po_distribution_id

Line 5484: FROM po_distributions_draft_all podd,

5480: NVL(podd.partial_funded_flag ,G_NULL_CHAR),
5481: NVL(podd.destination_type_code ,G_NULL_CHAR),
5482: NVL(podd.destination_subinventory ,G_NULL_CHAR)
5483: ) f_lock_attrs
5484: FROM po_distributions_draft_all podd,
5485: po_session_gt pogt
5486: WHERE podd.draft_id = p_draft_id
5487: AND podd.po_distribution_id = pogt.char1 -- po_distribution_id
5488: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID

Line 8353: FROM po_distributions_draft_all

8349:
8350:
8351: FORALL itr IN 1..po_dest_line_ids_tbl.Count
8352: DELETE
8353: FROM po_distributions_draft_all
8354: WHERE po_distribution_id = po_dest_line_ids_tbl(itr)
8355: AND draft_id = p_po_draft_id;
8356:
8357: FORALL itr IN 1..po_dest_line_ids_tbl.Count

Line 8793: FROM po_distributions_draft_all

8789: -- delete distributions data
8790: SELECT po_distribution_id
8791: BULK COLLECT
8792: INTO l_distribution_id_tbl
8793: FROM po_distributions_draft_all
8794: WHERE delete_flag = 'Y'
8795: AND draft_id = p_draft_id
8796: AND NVL(change_accepted_flag, 'Y') = 'Y';
8797:

Line 8809: DELETE FROM po_distributions_draft_all

8805: PO_REQ_LINES_SV.update_req_for_linked_po_count (l_distribution_id_tbl, 'DISTRIBUTION MOD');
8806: END IF;
8807:
8808: FORALL i IN 1..l_distribution_id_tbl.Count()
8809: DELETE FROM po_distributions_draft_all
8810: WHERE po_distribution_id = l_distribution_id_tbl(i)
8811: AND draft_id = p_draft_id;
8812:
8813: IF (PO_LOG.d_stmt) THEN