DBA Data[Home] [Help]

APPS.GMPMPACT dependencies on GME_BATCH_HEADER

Line 529: FROM gme_batch_header

525: WHERE schedule_id = G_schedule_id;
526:
527: CURSOR Cur_fpo_doc_no IS
528: SELECT batch_no
529: FROM gme_batch_header
530: WHERE batch_type = 10
531: AND batch_id = G_doc_id
532: AND organization_id = V_organization_id
533: AND delete_mark = 0;

Line 537: FROM gme_batch_header

533: AND delete_mark = 0;
534:
535: CURSOR Cur_prod_doc_no IS
536: SELECT batch_no
537: FROM gme_batch_header
538: WHERE batch_type = 0
539: AND batch_id = G_doc_id
540: AND organization_id = V_organization_id
541: AND delete_mark = 0;

Line 787: ' gme_batch_header gbh, '||

783: ' NULL '||
784: ' ))) trans_qty2, '||
785: ' gmd.material_detail_id line_id, mp.organization_code inv_org_code'||
786: ' FROM '||
787: ' gme_batch_header gbh, '||
788: ' gme_material_details gmd, '||
789: ' mtl_parameters mp, '||
790: ' hr_organization_units hou, '||
791: ' mtl_system_items msi '||