DBA Data[Home] [Help]

APPS.GMPMPACT dependencies on GME_BATCH_HEADER

Line 531: FROM gme_batch_header

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

Line 539: FROM gme_batch_header

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

Line 789: ' gme_batch_header gbh, '||

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