APPS.PO_PDOI_ATTR_PROCESS_PVT dependencies on PO_ATTRIBUTE_VALUES_DRAFT

Line 259: FROM po_attribute_values_draft

255: SELECT l_key,
256: x_processing_row_tbl(i),
257: attribute_values_id,
258: 'DRAFT'
259: FROM po_attribute_values_draft
260: WHERE draft_id = x_attr_values.draft_id_tbl(i)
261: AND po_line_id = x_attr_values.ln_po_line_id_tbl(i)
262: AND org_id = x_attr_values.org_id_tbl(i);
263:

Line 877: FROM po_attribute_values_draft

873: AND msi.inventory_item_id (+)= draft_lines.item_id -- Bug7039409: Join msi
874: AND msi.organization_id (+)= l_inv_org_id -- Bug7039409: Join msi
875: AND NOT EXISTS
876: (SELECT 1
877: FROM po_attribute_values_draft
878: WHERE po_line_id = draft_lines.po_line_id
879: AND draft_id = draft_lines.draft_id);
880:
881: IF (PO_LOG.d_stmt) THEN

Line 894: INSERT INTO po_attribute_values_draft

890: d_position := 10;
891:
892: -- create default attr rows
893: FORALL i IN 1..l_draft_id_tbl.COUNT
894: INSERT INTO po_attribute_values_draft
895: (
896: ATTRIBUTE_VALUES_ID,
897: DRAFT_ID,
898: PO_LINE_ID,

Line 998: po_attribute_values_draft pavd

994: l_mfg_name_tbl
995: FROM mtl_mfg_part_numbers_all_v mmpn
996: WHERE row_id IN (SELECT MIN(mmpn2.row_id)
997: FROM mtl_mfg_part_numbers_all_v mmpn2,
998: po_attribute_values_draft pavd
999: WHERE pavd.inventory_item_id = mmpn2.inventory_item_id
1000: AND mmpn2.organization_id = l_master_org_id
1001: AND pavd.request_id = fnd_global.conc_request_id
1002: AND pavd.program_application_id = fnd_global.prog_appl_id

Line 1012: -- Bug7039409: update po_attribute_values_draft.manufacturer_part_num

1008: PO_LOG.stmt(d_module, d_position, 'l_mfg_part_num_tbl', l_mfg_part_num_tbl);
1009: PO_LOG.stmt(d_module, d_position, 'l_mfg_name_tbl', l_mfg_name_tbl);
1010: END IF;
1011:
1012: -- Bug7039409: update po_attribute_values_draft.manufacturer_part_num
1013: FORALL i IN 1..l_item_id_tbl2.COUNT
1014: UPDATE po_attribute_values_draft
1015: SET manufacturer_part_num = l_mfg_part_num_tbl(i)
1016: WHERE inventory_item_id = l_item_id_tbl2(i)

Line 1014: UPDATE po_attribute_values_draft

1010: END IF;
1011:
1012: -- Bug7039409: update po_attribute_values_draft.manufacturer_part_num
1013: FORALL i IN 1..l_item_id_tbl2.COUNT
1014: UPDATE po_attribute_values_draft
1015: SET manufacturer_part_num = l_mfg_part_num_tbl(i)
1016: WHERE inventory_item_id = l_item_id_tbl2(i)
1017: AND org_id = l_master_org_id
1018: AND request_id = fnd_global.conc_request_id