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_MOD_SYNC_PROCESS_PVT dependencies on PO_HEADERS_ALL_EXT_B

Line 2430: INTO po_headers_all_ext_b phbd

2426: PO_LOG.stmt(d_module,d_position ,'PODraft Header Id', l_po_header_id);
2427: END IF;
2428:
2429: MERGE
2430: INTO po_headers_all_ext_b phbd
2431: USING
2432: (SELECT phb1.extension_id ,
2433: phb1.attr_group_id ,
2434: phb1.po_header_id ,

Line 2539: FROM po_headers_all_ext_b phb1

2535: phb1.d_ext_attr10 ,
2536: phb1.uda_template_id ,
2537: phb1.draft_id ,
2538: phb1.revision_num
2539: FROM po_headers_all_ext_b phb1
2540: WHERE phb1.draft_id = -1
2541: AND phb1.po_header_id = l_po_header_id
2542: -- exclude Mod specific and doc numbering attribute groups
2543: AND NOT EXISTS (SELECT 'Mod specific or doc numbering attribute groups'

Line 2881: PO_LOG.stmt(d_module,d_position ,'Updated po_headers_all_ext_b for Single Row attr grp and c_ext_attr40 not in PO_UDA_ADDRESS_TYPES');

2877:
2878:
2879: d_position := 30;
2880: IF (PO_LOG.d_stmt) THEN
2881: PO_LOG.stmt(d_module,d_position ,'Updated po_headers_all_ext_b for Single Row attr grp and c_ext_attr40 not in PO_UDA_ADDRESS_TYPES');
2882: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
2883: END IF;
2884:
2885: -- Update multi Row header Ext n rev num

Line 2886: DELETE FROM po_headers_all_ext_b pheb

2882: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
2883: END IF;
2884:
2885: -- Update multi Row header Ext n rev num
2886: DELETE FROM po_headers_all_ext_b pheb
2887: WHERE pheb.po_header_id=l_po_header_id
2888: AND pheb.draft_id = p_draft_id
2889: AND (pheb.c_ext_attr40 NOT IN ('PO_UDA_ADDRESS_TYPES', 'PO_MOD_UDA_ADDRESS_TYPES')
2890: OR pheb.c_ext_attr40 IS NULL)

Line 2903: PO_LOG.stmt(d_module,d_position ,'Deleted from po_headers_all_ext_b for Multi Row attr grp and c_ext_attr40 not in PO_UDA_ADDRESS_TYPES');

2899: WHERE pheb.attr_group_id = ag.attr_group_id
2900: AND ag.multi_row = 'Y');
2901: d_position := 40;
2902: IF (PO_LOG.d_stmt) THEN
2903: PO_LOG.stmt(d_module,d_position ,'Deleted from po_headers_all_ext_b for Multi Row attr grp and c_ext_attr40 not in PO_UDA_ADDRESS_TYPES');
2904: END IF;
2905:
2906: INSERT INTO po_headers_all_ext_b phbd
2907: ( phbd.extension_id ,

Line 2906: INSERT INTO po_headers_all_ext_b phbd

2902: IF (PO_LOG.d_stmt) THEN
2903: PO_LOG.stmt(d_module,d_position ,'Deleted from po_headers_all_ext_b for Multi Row attr grp and c_ext_attr40 not in PO_UDA_ADDRESS_TYPES');
2904: END IF;
2905:
2906: INSERT INTO po_headers_all_ext_b phbd
2907: ( phbd.extension_id ,
2908: phbd.attr_group_id ,
2909: phbd.po_header_id ,
2910: phbd.data_level_id ,

Line 3122: FROM po_headers_all_ext_b phb --base

3118: phb.d_ext_attr10,
3119: phb.uda_template_id ,
3120: p_draft_id ,
3121: phb.revision_num
3122: FROM po_headers_all_ext_b phb --base
3123: WHERE phb.draft_id = -1
3124: AND phb.po_header_id = l_po_header_id
3125: AND (phb.c_ext_attr40 NOT IN ('PO_UDA_ADDRESS_TYPES', 'PO_MOD_UDA_ADDRESS_TYPES')
3126: OR phb.c_ext_attr40 IS NULL)

Line 3140: PO_LOG.stmt(d_module,d_position ,'Inserted Into po_headers_all_ext_b for Multi Row attr grp from base tables');

3136: AND ag.multi_row = 'Y');
3137:
3138: d_position :=60;
3139: IF (PO_LOG.d_stmt) THEN
3140: PO_LOG.stmt(d_module,d_position ,'Inserted Into po_headers_all_ext_b for Multi Row attr grp from base tables');
3141: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
3142: END IF;
3143:
3144:

Line 3148: FROM po_headers_all_ext_b b

3144:
3145: SELECT b.extension_id
3146: BULK COLLECT
3147: INTO l_entension_id_tbl
3148: FROM po_headers_all_ext_b b
3149: WHERE draft_id = p_draft_id
3150: AND po_header_id = l_po_header_id
3151: AND NOT EXISTS (SELECT 'tl table record exists'
3152: FROM po_headers_all_ext_tl tl

Line 3175: FROM po_headers_all_ext_b phb

3171: AND pel.entity_pk1= phaet.po_header_id
3172: AND pel.entity_name = PO_DRAFTS_PVT.G_LOCK_HEADER_ENTITY
3173: AND pel.lock_by_draft_id = p_draft_id )
3174: AND NOT EXISTS (SELECT 'Exclude Uda attributes'
3175: FROM po_headers_all_ext_b phb
3176: WHERE PHB.EXTENSION_ID = phaet.EXTENSION_ID
3177: AND phb.c_ext_attr40 = 'PO_UDA_ADDRESS_TYPES'
3178: );
3179:

Line 3219: FROM po_headers_all_ext_b b,

3215: b.created_by,
3216: b.creation_date ,
3217: b.uda_template_id,
3218: p_draft_id
3219: FROM po_headers_all_ext_b b,
3220: fnd_languages l
3221: WHERE b.extension_id = l_entension_id_tbl(i)
3222: AND l.installed_flag IN ('B', 'I')
3223: ;

Line 4477: UPDATE po_headers_all_ext_b phbd

4473: IF (PO_LOG.d_stmt) THEN
4474: PO_LOG.stmt(d_module,d_position ,'Header Id', l_po_header_id);
4475: END IF;
4476:
4477: UPDATE po_headers_all_ext_b phbd
4478: SET ( phbd.c_ext_attr1,
4479: phbd.c_ext_attr2 ,
4480: phbd.c_ext_attr3 ,
4481: phbd.c_ext_attr4 ,

Line 4661: FROM po_headers_all_ext_b phb--base

4657: phb.d_ext_attr8 ,
4658: phb.d_ext_attr9 ,
4659: phb.d_ext_attr10 ,
4660: phb.revision_num
4661: FROM po_headers_all_ext_b phb--base
4662: WHERE phb.po_header_id = phbd.po_header_id
4663: AND phb.draft_id = -1
4664: AND phb.attr_group_id = phbd.attr_group_id
4665: AND phb.c_ext_attr39=phbd.c_ext_attr39

Line 4685: FROM po_headers_all_ext_b phb,

4681: AND pel.entity_pk2= phbd.c_ext_attr39
4682: AND pel.entity_name = PO_DRAFTS_PVT.G_LOCK_ADDRESS_ENTITY
4683: AND pel.lock_by_draft_id = p_draft_id )
4684: AND EXISTS (SELECT 'base.rev_num>draft.rev_num'
4685: FROM po_headers_all_ext_b phb,
4686: po_drafts dft
4687: WHERE ( (p_ignore_rev_number ='Y') OR (NVL(phb.revision_num,0) > NVL(phbd.revision_num,0) OR NVL(dft.revision_num,0) = -1))
4688: AND phb.draft_id = -1
4689: AND phb.po_header_id=l_po_header_id