eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_PDOI_ATTR_PROCESS_PVT dependencies on PO_ATTRIBUTE_VALUES

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 278: FROM po_attribute_values

274: SELECT l_key,
275: x_processing_row_tbl(i),
276: attribute_values_id,
277: 'TXN'
278: FROM po_attribute_values
279: WHERE po_line_id = x_attr_values.ln_po_line_id_tbl(i)
280: AND org_id = x_attr_values.org_id_tbl(i);
281: END IF;
282:

Line 634: FROM po_attribute_values_tlp_draft

630: SELECT l_key,
631: x_processing_row_tbl(i),
632: attribute_values_tlp_id,
633: 'DRAFT'
634: FROM po_attribute_values_tlp_draft
635: WHERE draft_id = x_attr_values_tlp.draft_id_tbl(i)
636: AND po_line_id = x_attr_values_tlp.ln_po_line_id_tbl(i)
637: AND language = x_attr_values_tlp.language_tbl(i)
638: AND org_id = x_attr_values_tlp.org_id_tbl(i);

Line 654: FROM po_attribute_values_tlp

650: SELECT l_key,
651: x_processing_row_tbl(i),
652: attribute_values_tlp_id,
653: 'TXN'
654: FROM po_attribute_values_tlp
655: WHERE po_line_id = x_attr_values_tlp.ln_po_line_id_tbl(i)
656: AND language = x_attr_values_tlp.language_tbl(i)
657: AND org_id = x_attr_values_tlp.org_id_tbl(i);
658: END IF;

Line 798: l_master_org_id PO_ATTRIBUTE_VALUES.org_id%TYPE;

794: l_item_desc_tbl PO_TBL_VARCHAR2000;
795: l_created_lang_tbl PO_TBL_VARCHAR5;
796:
797: -- Bug7039409: Declared new variables
798: l_master_org_id PO_ATTRIBUTE_VALUES.org_id%TYPE;
799: l_inv_org_id PO_ATTRIBUTE_VALUES.org_id%TYPE;
800: l_item_id_tbl2 PO_TBL_NUMBER; -- Different from l_item_id_tbl
801: l_lead_time_tbl PO_TBL_NUMBER;
802: l_mfg_part_num_tbl PO_TBL_VARCHAR2000;

Line 799: l_inv_org_id PO_ATTRIBUTE_VALUES.org_id%TYPE;

795: l_created_lang_tbl PO_TBL_VARCHAR5;
796:
797: -- Bug7039409: Declared new variables
798: l_master_org_id PO_ATTRIBUTE_VALUES.org_id%TYPE;
799: l_inv_org_id PO_ATTRIBUTE_VALUES.org_id%TYPE;
800: l_item_id_tbl2 PO_TBL_NUMBER; -- Different from l_item_id_tbl
801: l_lead_time_tbl PO_TBL_NUMBER;
802: l_mfg_part_num_tbl PO_TBL_VARCHAR2000;
803: l_mfg_name_tbl PO_TBL_VARCHAR2000;

Line 869: FROM po_attribute_values_draft

865: AND msi.inventory_item_id (+)= draft_lines.item_id -- Bug7039409: Join msi
866: AND msi.organization_id (+)= l_inv_org_id -- Bug7039409: Join msi
867: AND NOT EXISTS
868: (SELECT 1
869: FROM po_attribute_values_draft
870: WHERE po_line_id = draft_lines.po_line_id
871: AND draft_id = draft_lines.draft_id);
872:
873: IF (PO_LOG.d_stmt) THEN

Line 886: INSERT INTO po_attribute_values_draft

882: d_position := 10;
883:
884: -- create default attr rows
885: FORALL i IN 1..l_draft_id_tbl.COUNT
886: INSERT INTO po_attribute_values_draft
887: (
888: ATTRIBUTE_VALUES_ID,
889: DRAFT_ID,
890: PO_LINE_ID,

Line 909: PO_ATTRIBUTE_VALUES_S.nextval,

905: PROGRAM_UPDATE_DATE
906: )
907: VALUES
908: (
909: PO_ATTRIBUTE_VALUES_S.nextval,
910: l_draft_id_tbl(i),
911: l_po_line_id_tbl(i),
912: '-2', -- REQ_TEMPLATE_NAME
913: -2, --REQ_TEMPLATE_LINE_NUM

Line 933: INSERT INTO po_attribute_values_tlp_draft

929: d_position := 20;
930:
931: -- create default attr_tlp rows in document created languages
932: FORALL i IN 1..l_draft_id_tbl.COUNT
933: INSERT INTO po_attribute_values_tlp_draft
934: (
935: ATTRIBUTE_VALUES_TLP_ID,
936: DRAFT_ID,
937: PO_LINE_ID,

Line 957: PO_ATTRIBUTE_VALUES_TLP_S.nextval,

953: PROGRAM_UPDATE_DATE
954: )
955: VALUES
956: (
957: PO_ATTRIBUTE_VALUES_TLP_S.nextval,
958: l_draft_id_tbl(i),
959: l_po_line_id_tbl(i),
960: '-2', -- REQ_TEMPLATE_NAME
961: -2, --REQ_TEMPLATE_LINE_NUM

Line 990: po_attribute_values_draft pavd

986: l_mfg_name_tbl
987: FROM mtl_mfg_part_numbers_all_v mmpn
988: WHERE row_id IN (SELECT MIN(mmpn2.row_id)
989: FROM mtl_mfg_part_numbers_all_v mmpn2,
990: po_attribute_values_draft pavd
991: WHERE pavd.inventory_item_id = mmpn2.inventory_item_id
992: AND mmpn2.organization_id = l_master_org_id
993: AND pavd.request_id = fnd_global.conc_request_id
994: AND pavd.program_application_id = fnd_global.prog_appl_id

Line 1004: -- Bug7039409: update po_attribute_values_draft.manufacturer_part_num

1000: PO_LOG.stmt(d_module, d_position, 'l_mfg_part_num_tbl', l_mfg_part_num_tbl);
1001: PO_LOG.stmt(d_module, d_position, 'l_mfg_name_tbl', l_mfg_name_tbl);
1002: END IF;
1003:
1004: -- Bug7039409: update po_attribute_values_draft.manufacturer_part_num
1005: FORALL i IN 1..l_item_id_tbl2.COUNT
1006: UPDATE po_attribute_values_draft
1007: SET manufacturer_part_num = l_mfg_part_num_tbl(i)
1008: WHERE inventory_item_id = l_item_id_tbl2(i)

Line 1006: UPDATE po_attribute_values_draft

1002: END IF;
1003:
1004: -- Bug7039409: update po_attribute_values_draft.manufacturer_part_num
1005: FORALL i IN 1..l_item_id_tbl2.COUNT
1006: UPDATE po_attribute_values_draft
1007: SET manufacturer_part_num = l_mfg_part_num_tbl(i)
1008: WHERE inventory_item_id = l_item_id_tbl2(i)
1009: AND org_id = l_master_org_id
1010: AND request_id = fnd_global.conc_request_id

Line 1014: -- Bug7039409: update po_attribute_values_tlp_draft.manufacturer

1010: AND request_id = fnd_global.conc_request_id
1011: AND program_application_id = fnd_global.prog_appl_id
1012: AND program_id = fnd_global.conc_program_id;
1013:
1014: -- Bug7039409: update po_attribute_values_tlp_draft.manufacturer
1015: FORALL i IN 1..l_item_id_tbl2.COUNT
1016: UPDATE po_attribute_values_tlp_draft
1017: SET manufacturer = l_mfg_name_tbl(i)
1018: WHERE inventory_item_id = l_item_id_tbl2(i)

Line 1016: UPDATE po_attribute_values_tlp_draft

1012: AND program_id = fnd_global.conc_program_id;
1013:
1014: -- Bug7039409: update po_attribute_values_tlp_draft.manufacturer
1015: FORALL i IN 1..l_item_id_tbl2.COUNT
1016: UPDATE po_attribute_values_tlp_draft
1017: SET manufacturer = l_mfg_name_tbl(i)
1018: WHERE inventory_item_id = l_item_id_tbl2(i)
1019: AND org_id = l_master_org_id
1020: AND request_id = fnd_global.conc_request_id

Line 1024: -- Bug7039409: update po_attribute_values_tlp_draft.long_description

1020: AND request_id = fnd_global.conc_request_id
1021: AND program_application_id = fnd_global.prog_appl_id
1022: AND program_id = fnd_global.conc_program_id;
1023:
1024: -- Bug7039409: update po_attribute_values_tlp_draft.long_description
1025: UPDATE po_attribute_values_tlp_draft pavd_tlp
1026: SET long_description = (SELECT long_description
1027: FROM mtl_system_items_tl msi_tl,
1028: fnd_languages lang

Line 1025: UPDATE po_attribute_values_tlp_draft pavd_tlp

1021: AND program_application_id = fnd_global.prog_appl_id
1022: AND program_id = fnd_global.conc_program_id;
1023:
1024: -- Bug7039409: update po_attribute_values_tlp_draft.long_description
1025: UPDATE po_attribute_values_tlp_draft pavd_tlp
1026: SET long_description = (SELECT long_description
1027: FROM mtl_system_items_tl msi_tl,
1028: fnd_languages lang
1029: WHERE msi_tl.inventory_item_id = pavd_tlp.inventory_item_id