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 639: FROM po_attribute_values_tlp_draft

635: SELECT l_key,
636: x_processing_row_tbl(i),
637: attribute_values_tlp_id,
638: 'DRAFT'
639: FROM po_attribute_values_tlp_draft
640: WHERE draft_id = x_attr_values_tlp.draft_id_tbl(i)
641: AND po_line_id = x_attr_values_tlp.ln_po_line_id_tbl(i)
642: AND language = x_attr_values_tlp.language_tbl(i)
643: AND org_id = x_attr_values_tlp.org_id_tbl(i);

Line 659: FROM po_attribute_values_tlp

655: SELECT l_key,
656: x_processing_row_tbl(i),
657: attribute_values_tlp_id,
658: 'TXN'
659: FROM po_attribute_values_tlp
660: WHERE po_line_id = x_attr_values_tlp.ln_po_line_id_tbl(i)
661: AND language = x_attr_values_tlp.language_tbl(i)
662: AND org_id = x_attr_values_tlp.org_id_tbl(i);
663: END IF;

Line 806: l_master_org_id PO_ATTRIBUTE_VALUES.org_id%TYPE;

802: l_item_desc_tbl PO_TBL_VARCHAR2000;
803: l_created_lang_tbl PO_TBL_VARCHAR5;
804:
805: -- Bug7039409: Declared new variables
806: l_master_org_id PO_ATTRIBUTE_VALUES.org_id%TYPE;
807: l_inv_org_id PO_ATTRIBUTE_VALUES.org_id%TYPE;
808: l_item_id_tbl2 PO_TBL_NUMBER; -- Different from l_item_id_tbl
809: l_lead_time_tbl PO_TBL_NUMBER;
810: l_mfg_part_num_tbl PO_TBL_VARCHAR2000;

Line 807: l_inv_org_id PO_ATTRIBUTE_VALUES.org_id%TYPE;

803: l_created_lang_tbl PO_TBL_VARCHAR5;
804:
805: -- Bug7039409: Declared new variables
806: l_master_org_id PO_ATTRIBUTE_VALUES.org_id%TYPE;
807: l_inv_org_id PO_ATTRIBUTE_VALUES.org_id%TYPE;
808: l_item_id_tbl2 PO_TBL_NUMBER; -- Different from l_item_id_tbl
809: l_lead_time_tbl PO_TBL_NUMBER;
810: l_mfg_part_num_tbl PO_TBL_VARCHAR2000;
811: l_mfg_name_tbl PO_TBL_VARCHAR2000;

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 917: PO_ATTRIBUTE_VALUES_S.nextval,

913: PROGRAM_UPDATE_DATE
914: )
915: VALUES
916: (
917: PO_ATTRIBUTE_VALUES_S.nextval,
918: l_draft_id_tbl(i),
919: l_po_line_id_tbl(i),
920: '-2', -- REQ_TEMPLATE_NAME
921: -2, --REQ_TEMPLATE_LINE_NUM

Line 941: INSERT INTO po_attribute_values_tlp_draft

937: d_position := 20;
938:
939: -- create default attr_tlp rows in document created languages
940: FORALL i IN 1..l_draft_id_tbl.COUNT
941: INSERT INTO po_attribute_values_tlp_draft
942: (
943: ATTRIBUTE_VALUES_TLP_ID,
944: DRAFT_ID,
945: PO_LINE_ID,

Line 965: PO_ATTRIBUTE_VALUES_TLP_S.nextval,

961: PROGRAM_UPDATE_DATE
962: )
963: VALUES
964: (
965: PO_ATTRIBUTE_VALUES_TLP_S.nextval,
966: l_draft_id_tbl(i),
967: l_po_line_id_tbl(i),
968: '-2', -- REQ_TEMPLATE_NAME
969: -2, --REQ_TEMPLATE_LINE_NUM

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

Line 1022: -- Bug7039409: update po_attribute_values_tlp_draft.manufacturer

1018: AND request_id = fnd_global.conc_request_id
1019: AND program_application_id = fnd_global.prog_appl_id
1020: AND program_id = fnd_global.conc_program_id;
1021:
1022: -- Bug7039409: update po_attribute_values_tlp_draft.manufacturer
1023: FORALL i IN 1..l_item_id_tbl2.COUNT
1024: UPDATE po_attribute_values_tlp_draft
1025: SET manufacturer = l_mfg_name_tbl(i)
1026: WHERE inventory_item_id = l_item_id_tbl2(i)

Line 1024: UPDATE po_attribute_values_tlp_draft

1020: AND program_id = fnd_global.conc_program_id;
1021:
1022: -- Bug7039409: update po_attribute_values_tlp_draft.manufacturer
1023: FORALL i IN 1..l_item_id_tbl2.COUNT
1024: UPDATE po_attribute_values_tlp_draft
1025: SET manufacturer = l_mfg_name_tbl(i)
1026: WHERE inventory_item_id = l_item_id_tbl2(i)
1027: AND org_id = l_master_org_id
1028: AND request_id = fnd_global.conc_request_id

Line 1032: -- Bug7039409: update po_attribute_values_tlp_draft.long_description

1028: AND request_id = fnd_global.conc_request_id
1029: AND program_application_id = fnd_global.prog_appl_id
1030: AND program_id = fnd_global.conc_program_id;
1031:
1032: -- Bug7039409: update po_attribute_values_tlp_draft.long_description
1033: -- Bug7722053: Added the condition to check the long desc value
1034: UPDATE po_attribute_values_tlp_draft pavd_tlp
1035: SET long_description = (SELECT long_description
1036: FROM mtl_system_items_tl msi_tl,

Line 1034: UPDATE po_attribute_values_tlp_draft pavd_tlp

1030: AND program_id = fnd_global.conc_program_id;
1031:
1032: -- Bug7039409: update po_attribute_values_tlp_draft.long_description
1033: -- Bug7722053: Added the condition to check the long desc value
1034: UPDATE po_attribute_values_tlp_draft pavd_tlp
1035: SET long_description = (SELECT long_description
1036: FROM mtl_system_items_tl msi_tl,
1037: fnd_languages lang
1038: WHERE msi_tl.inventory_item_id = pavd_tlp.inventory_item_id