DBA Data[Home] [Help]

APPS.WIP_OSP dependencies on FND_GLOBAL

Line 429: WHERE FU.USER_ID = FND_GLOBAL.User_Id

425: CURSOR Cemp IS
426: SELECT 'x'
427: FROM FND_USER FU,
428: PER_PEOPLE_F PPF
429: WHERE FU.USER_ID = FND_GLOBAL.User_Id
430: AND FU.EMPLOYEE_ID = PPF.PERSON_ID;
431:
432: /* You cannot move to queue of the first op if
433: * PO RECEIPT: The 1st op department has no location

Line 522: FND_GLOBAL.USER_ID,

518: autosource_flag, group_code, suggested_buyer_id,
519: project_id, task_id, project_accounting_context
520: )
521: SELECT SYSDATE,
522: FND_GLOBAL.USER_ID,
523: SYSDATE,
524: FND_GLOBAL.USER_ID,
525: FND_GLOBAL.LOGIN_ID,
526: FND_GLOBAL.CONC_REQUEST_ID,

Line 524: FND_GLOBAL.USER_ID,

520: )
521: SELECT SYSDATE,
522: FND_GLOBAL.USER_ID,
523: SYSDATE,
524: FND_GLOBAL.USER_ID,
525: FND_GLOBAL.LOGIN_ID,
526: FND_GLOBAL.CONC_REQUEST_ID,
527: FND_GLOBAL.PROG_APPL_ID,
528: FND_GLOBAL.CONC_PROGRAM_ID,

Line 525: FND_GLOBAL.LOGIN_ID,

521: SELECT SYSDATE,
522: FND_GLOBAL.USER_ID,
523: SYSDATE,
524: FND_GLOBAL.USER_ID,
525: FND_GLOBAL.LOGIN_ID,
526: FND_GLOBAL.CONC_REQUEST_ID,
527: FND_GLOBAL.PROG_APPL_ID,
528: FND_GLOBAL.CONC_PROGRAM_ID,
529: SYSDATE,

Line 526: FND_GLOBAL.CONC_REQUEST_ID,

522: FND_GLOBAL.USER_ID,
523: SYSDATE,
524: FND_GLOBAL.USER_ID,
525: FND_GLOBAL.LOGIN_ID,
526: FND_GLOBAL.CONC_REQUEST_ID,
527: FND_GLOBAL.PROG_APPL_ID,
528: FND_GLOBAL.CONC_PROGRAM_ID,
529: SYSDATE,
530: TO_NUMBER(hoi.ORG_INFORMATION3) operating_unit,

Line 527: FND_GLOBAL.PROG_APPL_ID,

523: SYSDATE,
524: FND_GLOBAL.USER_ID,
525: FND_GLOBAL.LOGIN_ID,
526: FND_GLOBAL.CONC_REQUEST_ID,
527: FND_GLOBAL.PROG_APPL_ID,
528: FND_GLOBAL.CONC_PROGRAM_ID,
529: SYSDATE,
530: TO_NUMBER(hoi.ORG_INFORMATION3) operating_unit,
531: fu.employee_id,

Line 528: FND_GLOBAL.CONC_PROGRAM_ID,

524: FND_GLOBAL.USER_ID,
525: FND_GLOBAL.LOGIN_ID,
526: FND_GLOBAL.CONC_REQUEST_ID,
527: FND_GLOBAL.PROG_APPL_ID,
528: FND_GLOBAL.CONC_PROGRAM_ID,
529: SYSDATE,
530: TO_NUMBER(hoi.ORG_INFORMATION3) operating_unit,
531: fu.employee_id,
532: 'WIP',

Line 647: AND FND_GLOBAL.User_Id = fu.user_id

643: for resources/assy of basis type ITEM. */
644: AND wor.basis_type = WIP_CONSTANTS.PER_ITEM
645: AND br.organization_id = msi.organization_id
646: AND br.purchase_item_id = msi.inventory_item_id
647: AND FND_GLOBAL.User_Id = fu.user_id
648: AND op1.organization_id = bd.organization_id
649: /* Fix for bug 3092030: Corrected condition to ensure we insert
650: correct deliver_to_location_id */
651: AND ( (wor.autocharge_type = WIP_CONSTANTS.PO_RECEIPT and

Line 717: FND_GLOBAL.USER_ID,

713: autosource_flag, group_code, suggested_buyer_id,
714: project_id, task_id, project_accounting_context
715: )
716: SELECT SYSDATE,
717: FND_GLOBAL.USER_ID,
718: SYSDATE,
719: FND_GLOBAL.USER_ID,
720: FND_GLOBAL.LOGIN_ID,
721: FND_GLOBAL.CONC_REQUEST_ID,

Line 719: FND_GLOBAL.USER_ID,

715: )
716: SELECT SYSDATE,
717: FND_GLOBAL.USER_ID,
718: SYSDATE,
719: FND_GLOBAL.USER_ID,
720: FND_GLOBAL.LOGIN_ID,
721: FND_GLOBAL.CONC_REQUEST_ID,
722: FND_GLOBAL.PROG_APPL_ID,
723: FND_GLOBAL.CONC_PROGRAM_ID,

Line 720: FND_GLOBAL.LOGIN_ID,

716: SELECT SYSDATE,
717: FND_GLOBAL.USER_ID,
718: SYSDATE,
719: FND_GLOBAL.USER_ID,
720: FND_GLOBAL.LOGIN_ID,
721: FND_GLOBAL.CONC_REQUEST_ID,
722: FND_GLOBAL.PROG_APPL_ID,
723: FND_GLOBAL.CONC_PROGRAM_ID,
724: SYSDATE,

Line 721: FND_GLOBAL.CONC_REQUEST_ID,

717: FND_GLOBAL.USER_ID,
718: SYSDATE,
719: FND_GLOBAL.USER_ID,
720: FND_GLOBAL.LOGIN_ID,
721: FND_GLOBAL.CONC_REQUEST_ID,
722: FND_GLOBAL.PROG_APPL_ID,
723: FND_GLOBAL.CONC_PROGRAM_ID,
724: SYSDATE,
725: TO_NUMBER(hoi.ORG_INFORMATION3) operating_unit,

Line 722: FND_GLOBAL.PROG_APPL_ID,

718: SYSDATE,
719: FND_GLOBAL.USER_ID,
720: FND_GLOBAL.LOGIN_ID,
721: FND_GLOBAL.CONC_REQUEST_ID,
722: FND_GLOBAL.PROG_APPL_ID,
723: FND_GLOBAL.CONC_PROGRAM_ID,
724: SYSDATE,
725: TO_NUMBER(hoi.ORG_INFORMATION3) operating_unit,
726: fu.employee_id,

Line 723: FND_GLOBAL.CONC_PROGRAM_ID,

719: FND_GLOBAL.USER_ID,
720: FND_GLOBAL.LOGIN_ID,
721: FND_GLOBAL.CONC_REQUEST_ID,
722: FND_GLOBAL.PROG_APPL_ID,
723: FND_GLOBAL.CONC_PROGRAM_ID,
724: SYSDATE,
725: TO_NUMBER(hoi.ORG_INFORMATION3) operating_unit,
726: fu.employee_id,
727: 'WIP',

Line 838: AND FND_GLOBAL.User_Id = fu.user_id

834: AND wor.organization_id = br.organization_id
835: AND wor.resource_id = br.resource_id
836: AND br.organization_id = msi.organization_id
837: AND br.purchase_item_id = msi.inventory_item_id
838: AND FND_GLOBAL.User_Id = fu.user_id
839: AND op1.organization_id = bd.organization_id
840: /* Fix for bug 3092030: Corrected condition to ensure we insert
841: correct deliver_to_location_id */
842: AND ( (wor.autocharge_type = WIP_CONSTANTS.PO_RECEIPT and