390: CURSOR Cemp IS
391: SELECT 'x'
392: FROM FND_USER FU,
393: PER_PEOPLE_F PPF
394: WHERE FU.USER_ID = FND_GLOBAL.User_Id
395: AND FU.EMPLOYEE_ID = PPF.PERSON_ID;
396:
397: /* You cannot move to queue of the first op if
398: * PO RECEIPT: The 1st op department has no location
479: autosource_flag, group_code, suggested_buyer_id,
480: project_id, task_id, project_accounting_context
481: )
482: SELECT SYSDATE,
483: FND_GLOBAL.USER_ID,
484: SYSDATE,
485: FND_GLOBAL.USER_ID,
486: FND_GLOBAL.LOGIN_ID,
487: FND_GLOBAL.CONC_REQUEST_ID,
481: )
482: SELECT SYSDATE,
483: FND_GLOBAL.USER_ID,
484: SYSDATE,
485: FND_GLOBAL.USER_ID,
486: FND_GLOBAL.LOGIN_ID,
487: FND_GLOBAL.CONC_REQUEST_ID,
488: FND_GLOBAL.PROG_APPL_ID,
489: FND_GLOBAL.CONC_PROGRAM_ID,
482: SELECT SYSDATE,
483: FND_GLOBAL.USER_ID,
484: SYSDATE,
485: FND_GLOBAL.USER_ID,
486: FND_GLOBAL.LOGIN_ID,
487: FND_GLOBAL.CONC_REQUEST_ID,
488: FND_GLOBAL.PROG_APPL_ID,
489: FND_GLOBAL.CONC_PROGRAM_ID,
490: SYSDATE,
483: FND_GLOBAL.USER_ID,
484: SYSDATE,
485: FND_GLOBAL.USER_ID,
486: FND_GLOBAL.LOGIN_ID,
487: FND_GLOBAL.CONC_REQUEST_ID,
488: FND_GLOBAL.PROG_APPL_ID,
489: FND_GLOBAL.CONC_PROGRAM_ID,
490: SYSDATE,
491: TO_NUMBER(hoi.ORG_INFORMATION3) operating_unit,
484: SYSDATE,
485: FND_GLOBAL.USER_ID,
486: FND_GLOBAL.LOGIN_ID,
487: FND_GLOBAL.CONC_REQUEST_ID,
488: FND_GLOBAL.PROG_APPL_ID,
489: FND_GLOBAL.CONC_PROGRAM_ID,
490: SYSDATE,
491: TO_NUMBER(hoi.ORG_INFORMATION3) operating_unit,
492: fu.employee_id,
485: FND_GLOBAL.USER_ID,
486: FND_GLOBAL.LOGIN_ID,
487: FND_GLOBAL.CONC_REQUEST_ID,
488: FND_GLOBAL.PROG_APPL_ID,
489: FND_GLOBAL.CONC_PROGRAM_ID,
490: SYSDATE,
491: TO_NUMBER(hoi.ORG_INFORMATION3) operating_unit,
492: fu.employee_id,
493: 'WIP',
595: for resources/assy of basis type ITEM. */
596: AND wor.basis_type = WIP_CONSTANTS.PER_ITEM
597: AND br.organization_id = msi.organization_id
598: AND br.purchase_item_id = msi.inventory_item_id
599: AND FND_GLOBAL.User_Id = fu.user_id
600: AND op1.organization_id = bd.organization_id
601: /* Fix for bug 3092030: Corrected condition to ensure we insert
602: correct deliver_to_location_id */
603: AND ( (wor.autocharge_type = WIP_CONSTANTS.PO_RECEIPT and
665: autosource_flag, group_code, suggested_buyer_id,
666: project_id, task_id, project_accounting_context
667: )
668: SELECT SYSDATE,
669: FND_GLOBAL.USER_ID,
670: SYSDATE,
671: FND_GLOBAL.USER_ID,
672: FND_GLOBAL.LOGIN_ID,
673: FND_GLOBAL.CONC_REQUEST_ID,
667: )
668: SELECT SYSDATE,
669: FND_GLOBAL.USER_ID,
670: SYSDATE,
671: FND_GLOBAL.USER_ID,
672: FND_GLOBAL.LOGIN_ID,
673: FND_GLOBAL.CONC_REQUEST_ID,
674: FND_GLOBAL.PROG_APPL_ID,
675: FND_GLOBAL.CONC_PROGRAM_ID,
668: SELECT SYSDATE,
669: FND_GLOBAL.USER_ID,
670: SYSDATE,
671: FND_GLOBAL.USER_ID,
672: FND_GLOBAL.LOGIN_ID,
673: FND_GLOBAL.CONC_REQUEST_ID,
674: FND_GLOBAL.PROG_APPL_ID,
675: FND_GLOBAL.CONC_PROGRAM_ID,
676: SYSDATE,
669: FND_GLOBAL.USER_ID,
670: SYSDATE,
671: FND_GLOBAL.USER_ID,
672: FND_GLOBAL.LOGIN_ID,
673: FND_GLOBAL.CONC_REQUEST_ID,
674: FND_GLOBAL.PROG_APPL_ID,
675: FND_GLOBAL.CONC_PROGRAM_ID,
676: SYSDATE,
677: TO_NUMBER(hoi.ORG_INFORMATION3) operating_unit,
670: SYSDATE,
671: FND_GLOBAL.USER_ID,
672: FND_GLOBAL.LOGIN_ID,
673: FND_GLOBAL.CONC_REQUEST_ID,
674: FND_GLOBAL.PROG_APPL_ID,
675: FND_GLOBAL.CONC_PROGRAM_ID,
676: SYSDATE,
677: TO_NUMBER(hoi.ORG_INFORMATION3) operating_unit,
678: fu.employee_id,
671: FND_GLOBAL.USER_ID,
672: FND_GLOBAL.LOGIN_ID,
673: FND_GLOBAL.CONC_REQUEST_ID,
674: FND_GLOBAL.PROG_APPL_ID,
675: FND_GLOBAL.CONC_PROGRAM_ID,
676: SYSDATE,
677: TO_NUMBER(hoi.ORG_INFORMATION3) operating_unit,
678: fu.employee_id,
679: 'WIP',
777: AND wor.organization_id = br.organization_id
778: AND wor.resource_id = br.resource_id
779: AND br.organization_id = msi.organization_id
780: AND br.purchase_item_id = msi.inventory_item_id
781: AND FND_GLOBAL.User_Id = fu.user_id
782: AND op1.organization_id = bd.organization_id
783: /* Fix for bug 3092030: Corrected condition to ensure we insert
784: correct deliver_to_location_id */
785: AND ( (wor.autocharge_type = WIP_CONSTANTS.PO_RECEIPT and