APPS.GMP_APS_WRITER dependencies on GMP_APS_OUTPUT_DTL

Line 327: ||' gmp_aps_output_dtl b '

323: ||' COUNT(distinct b.operation_seq_num) OVER (PARTITION BY '
324: ||' b.parent_header_id, b.group_id) oper_count , '
325: ||' max(b.last_unit_completion_date) OVER (PARTITION BY a.batch_id) Max_Step '
326: ||' FROM gmp_aps_output_tbl a,'
327: ||' gmp_aps_output_dtl b '
328: ||' WHERE b.load_type = 3 '
329: ||' AND b.parent_header_id = a.header_id '
330: ||' AND b.group_id = a.process_id '
331: ||' AND b.organization_id = a.organization_id ' -- For R12.0

Line 450: UPDATE gmp_aps_output_dtl

446: ELSE
447: gmp_debug_message(' step to be updated not in pending status '||operation_tab(oper_cnt).operation_seq_num );
448: -- No Update to steps (WIP or completed)
449: BEGIN
450: UPDATE gmp_aps_output_dtl
451: SET load_type = (load_type * -1)
452: WHERE operation_seq_num =
453: operation_tab(oper_cnt).operation_seq_num
454: AND wip_entity_id = p_batch_id

Line 506: UPDATE GMP_APS_OUTPUT_DTL gad

502:
503: BEGIN
504: gmp_debug_message(' Updating attribute9 with batchstep resource id' );
505:
506: UPDATE GMP_APS_OUTPUT_DTL gad
507: SET attribute9 = ( SELECT gbr.batchstep_resource_id
508: FROM GME_BATCH_HEADER gbh,
509: GME_BATCH_STEPS gbs,
510: GME_BATCH_STEP_ACTIVITIES gba,

Line 581: ||' ( SELECT count(*) from gmp_aps_output_dtl '

577: ||' MAX(aps.completion_date) OVER (PARTITION BY '
578: ||' final.batchstep_activity_id), '
579: ||' aps.resource_hour, ' -- APS Resource Usage
580: -- Is Charge exists
581: ||' ( SELECT count(*) from gmp_aps_output_dtl '
582: ||' WHERE wip_entity_id = aps.wip_entity_id '
583: ||' AND parent_header_id = aps.parent_header_id '
584: ||' AND group_id = aps.group_id '
585: ||' AND load_type = 10 '

Line 730: ||' FROM gmp_aps_output_dtl gad, '

726: ||' OVER (PARTITION BY gad.operation_seq_num, '
727: ||' gad.schedule_seq_num ) '
728: ||' - crd.delete_mark ) rsrc_count, '
729: ||' gao.inventory_item_id ' -- Bug: 8616967 Vpedarla
730: ||' FROM gmp_aps_output_dtl gad, '
731: ||' gmp_aps_output_tbl gao, '
732: ||' cr_rsrc_dtl crd, '
733: -- Sequence depdendency selection For R12.0
734: ||' ( SELECT operation_seq_num, parent_seq_num, schedule_seq_num, '

Line 739: ||' FROM gmp_aps_output_dtl '

735: ||' wip_entity_id, resource_id_new , '
736: ||' TO_NUMBER(attribute1) sequence_dependent_usage, '
737: ||' MIN(start_date) OVER (PARTITION BY '
738: ||' group_id, parent_header_id, schedule_seq_num) start_date '
739: ||' FROM gmp_aps_output_dtl '
740: ||' WHERE parent_header_id = :phdr2 '
741: ||' AND group_id = :PGRP2 '
742: ||' AND wip_entity_id = :PBATCH2 '
743: ||' AND load_type = 1 '

Line 1080: UPDATE GMP_APS_OUTPUT_DTL

1076: BEGIN
1077: IF p_action_type = 1 THEN
1078: -- New batch
1079:
1080: UPDATE GMP_APS_OUTPUT_DTL
1081: SET attribute9 = new_batchstep_resource_id,
1082: attribute10 = or_tab(j).APS_UOM_CODE
1083: WHERE load_type IN (4,9) -- For R12.0
1084: AND resource_id_new = or_tab(j).aps_resource_id

Line 1101: UPDATE GMP_APS_OUTPUT_DTL

1097: ) ;
1098:
1099: ELSE
1100: -- Reschedule batch (Update the count as APS does not provide)
1101: UPDATE GMP_APS_OUTPUT_DTL
1102: SET attribute9 = new_batchstep_resource_id,
1103: attribute10 = or_tab(j).APS_UOM_CODE,
1104: assigned_units = rsrc_cnt
1105: WHERE load_type IN (4,9) -- For R12.0

Line 1167: -- WIP resource_instance_id then update GMP_APS_OUTPUT_DTL table

1163: END IF; /* End if for rreturn_status */
1164:
1165: -- NOTE:
1166: -- GMPOUTIB.pls will populate column resource_instance_number with
1167: -- WIP resource_instance_id then update GMP_APS_OUTPUT_DTL table
1168: -- resource_instance_id column
1169: -- with actual resource_instance_id from GMP_RESOURCE_INSTACNES table
1170:
1171: -- Update the resource level transactions if instance level transactions

Line 1175: UPDATE gmp_aps_output_dtl

1171: -- Update the resource level transactions if instance level transactions
1172: -- are present
1173: BEGIN
1174:
1175: UPDATE gmp_aps_output_dtl
1176: SET load_type = (load_type * -1)
1177: WHERE load_type = 4
1178: AND group_id = p_group_id
1179: AND parent_header_id = p_header_id

Line 1186: FROM gmp_aps_output_dtl b

1182: schedule_seq_num) IN
1183: ( SELECT b.operation_Seq_num,
1184: nvl(b.parent_seq_num,b.resource_seq_num),
1185: b.schedule_seq_num
1186: FROM gmp_aps_output_dtl b
1187: WHERE b.group_id = p_group_id
1188: AND b.parent_header_id = p_header_id
1189: AND b.load_type = 9 ) ;
1190: EXCEPTION

Line 1218: ||' FROM gmp_aps_output_dtl gad, '

1214: ||' gad.completion_date, '
1215: ||' gad.resource_instance_id , ' -- For R12.0
1216: ||' gme.USAGE_UM , ' --Bug: 8616967 Vpedarla
1217: ||' gao.inventory_item_id ' --Bug: 8616967 Vpedarla
1218: ||' FROM gmp_aps_output_dtl gad, '
1219: ||' gmp_aps_output_tbl gao, '
1220: ||' cr_rsrc_dtl crd , '
1221: ||' gme_batch_step_resources gme ' --Bug: 8616967 Vpedarla
1222: ||' WHERE '

Line 2062: gmp_aps_output_dtl gad,

2058: -- For R12.0
2059: BEGIN
2060: SELECT count(*) INTO v_plan_charges
2061: FROM
2062: gmp_aps_output_dtl gad,
2063: gme_batch_steps gbs
2064: WHERE gad.wip_entity_id = pbatch_id
2065: AND gad.load_type = 10
2066: AND gbs.batch_id = gad.wip_entity_id

Line 2552: ||' FROM gmp_aps_output_dtl a, '

2548: ||' OVER (PARTITION BY a.operation_seq_num ) aps_activity_sum, '
2549: ||' count(a.resource_id_new) '
2550: ||' OVER (PARTITION BY a.operation_seq_num, '
2551: ||' a.schedule_seq_num) aps_resource_sum '
2552: ||' FROM gmp_aps_output_dtl a, '
2553: ||' gmp_aps_output_tbl b '
2554: ||' WHERE a.parent_header_id = b.header_id '
2555: ||' AND a.group_id = b.process_id '
2556: ||' AND b.process_id = :pgrp2 '

Line 2986: FROM gmp_aps_output_dtl gad,

2982: gad.last_updated_by,
2983: gad.last_update_date,
2984: gad.creation_date,
2985: gad.created_by
2986: FROM gmp_aps_output_dtl gad,
2987: gmp_aps_output_tbl gao,
2988: gme_batch_steps gbs,
2989: cr_rsrc_dtl crd
2990: WHERE gad.parent_header_id = gao.header_id