DBA Data[Home] [Help]

APPS.WIP_OSP dependencies on FND_GLOBAL

Line 394: WHERE FU.USER_ID = FND_GLOBAL.User_Id

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

Line 483: FND_GLOBAL.USER_ID,

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,

Line 485: FND_GLOBAL.USER_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,

Line 486: FND_GLOBAL.LOGIN_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,

Line 487: FND_GLOBAL.CONC_REQUEST_ID,

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,

Line 488: FND_GLOBAL.PROG_APPL_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,
492: fu.employee_id,

Line 489: FND_GLOBAL.CONC_PROGRAM_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',

Line 599: AND FND_GLOBAL.User_Id = fu.user_id

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

Line 669: FND_GLOBAL.USER_ID,

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,

Line 671: FND_GLOBAL.USER_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,

Line 672: FND_GLOBAL.LOGIN_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,

Line 673: FND_GLOBAL.CONC_REQUEST_ID,

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,

Line 674: FND_GLOBAL.PROG_APPL_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,
678: fu.employee_id,

Line 675: FND_GLOBAL.CONC_PROGRAM_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',

Line 781: AND FND_GLOBAL.User_Id = fu.user_id

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